Considering the function below, is it possible to get the value of
the album_id from the first INSERT statement and use it in the 2nd
INSERT statement as I have tried to do here? Or do has the sequence
not update until the end of the LOOP?
I have tried this and get: ERROR: Attribute 'album_album_id_seq' not found
How would I accomplish this?
CREATE FUNCTION catalog_batch() RETURNS text AS '
DECLARE
myrec RECORD;
BEGIN
FOR myrec IN SELECT * FROM catalog LOOP
INSERT INTO album (columns,....) VALUES ('matching values',....);
INSERT INTO track (columns,....) VALUES (
currval(album_album_id_seq), 'other matching values',.... );
<rest of code>
END LOOP;
RETURN 'Batch Complete';
END;
' LANGUAGE 'plpgsql';
Thanks,
Dan Jewett